<html>
<head>
<meta http-equiv="Content-Type"content="text/html; charset=UTF-8" />
<title>社团信息显示</title>
</head>
<body>
<center>《<?php
include("../functions/db_conn.php");
$No = $_GET['SociNo'];
$ShowJob_sql = "SELECT * FROM Soci s, job j WHERE
s.SociNo=j.SociNo and s.SociNo='".$No."'";
$ShowJobResult = mysql_query($ShowJob_sql);
$row = mysql_fetch_array($ShowJobResult);
echo "<b><font color=red>".$row['SociName']."</font></b>";
?>》岗位列表</center>
<table width="560" border="1" align="center" cellpadding="0" cellspacing="1">
    <tr bgcolor="#0066CC" align="center">
        <td width="80"><font color="#FFFFFF"><b>岗位编号</b></font></td>
        <td width="80"><font color="#FFFFFF"><b>岗位名称</b></font></td>
        <td width="200"><font color="#FFFFFF" align="center">岗位介绍<b></b></font></td>
    </tr>
    <br />
<?php
$number = mysql_num_rows($ShowJobResult); 

if ($number>0) { 
    for ($i = 0; $i < $number; $i++)
    {
       
       echo "<tr  align='center'>";
       echo "<td width='80'>".$row['JobNo']."</td>";
       echo "<td width='80'>".$row['JobName']."</td>";
       echo "<td width='200'>".$row['JobInfo']."</td>";
       echo "</tr>"; 
       $row = mysql_fetch_array($ShowJobResult);
   }
}
?>

</table>
<center><br /><a href='#' onclick='javascript:window.history.go(-1);return false'>返回</a><br></center>
</center>
</body>
</html>
